package com.sun.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.sun.pojo.SchoolName;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;
import org.springframework.stereotype.Repository;

import java.util.Collection;
import java.util.List;
import java.util.Map;


@Mapper
@Repository
//@Component("nameMapper")
public interface NameMapper extends BaseMapper<SchoolName> {


//    @Select("select * from school_name")
    Collection<SchoolName> selectAll();
    List<SchoolName> selectAllDate();
    List<SchoolName> selectNameDate(String name);
    Collection<Map<String, Integer>> selectType();
    Collection<Map<String, Integer>> selectTypeB();
    Collection<Map<String, Integer>> select985();
    Collection<Map<String, Integer>> select211();
    Collection<Map<String, Integer>> selectCount985();
    Collection<Map<String, Integer>> selectCount211();
    Collection<Map<String, Integer>> selectTypeTop5();

    List<Map> selectDate(String name);
}
